JDPDatabaseMaint

Database Maintenance
[Back]

The Database Manager allows you to perform some of the basic functions necessary for maintaining or creating your database tables.

You may also create and maintain templates of your tables using the built in template manager.

To create or modify tables:
1. Open the datasource in the tree where you require your new table.
2. Enter a username and password for this datasource if prompted.
3. Either select the table you want to modify by clicking on it or click on the Tables entry of the tree to display a popup. Clicking on a previously selected table will also bring up a popup of choices.
4. Choose the appropriate action from the popup depending on whether you are creating a new table or modifying an existing table.
5. Make the necessary changes or enter the required columns and their attributes and then save them by pressing the Save button.
6. Some databases may experience problems when creating or modifying tables. If you could report these problems to us we will resolve them as quickly as possible.
To create a template:
1. Create a template group if you haven't already. You can call this anything you like. Do this by clicking on the Database Wizard Templates entry in the tree.
2. Create a template by clicking on your group name. Select New Template from the popup.
3. Enter the columns and their settings for this template.
4. Press the Save button to save this template.
5. You can modify templates by selecting them in the tree and making changes as outlined above.
Creating tables from templates and templates from tables:
1. Select the table or template that you wish to copy.
2. Drag it to the Tables group of the datasource or the Template group and drop it there.
3. Make the necessary changes and press the Save button to save the new Table or Template.

The Database Manager will automatically unload a table and reload it if you make changes that require the table to be re-created. In many cases changing a column type may cause an error when trying to reload the existing data. If this occurs the table data will be saved into another table so you can manually reload in using another utility. We will incorporate more powerful functionality into the coming future releases to cater for these types of problems.

Some data types are not fully supported by some databases. The best policy is just to try each data type to see whether your database supports it.

Please use caution when making table alterations using the Database Manager as extensive testing on the various ODBC databases has not yet been done.

Any errors that occur when creating or modifying tables will be reported in the Java Console. When reporting errors to BulletProof please copy the Java console into your email by selecting the contents and pressing Ctrl-C and then paste it into your email using Ctrl-V.

[Back]